export const UserQueries = {
    GetUsers: `
    SELECT
      id,
      userId,
      userName,
      employeeId,
      userPassword,
      userPhotoPath,
      userRoles,
      userEmail,
      userCellphone,
      userGender,
      userBirthday,
      userDepartment,
      userIdentity
    FROM my_schema.user
    `,
  
    GetUserById: `
    SELECT
      id,
      userId,
      userName,
      employeeId,
      userPassword,
      userPhotoPath,
      userRoles,
      userEmail,
      userCellphone,
      userGender,
      userBirthday,
      userDepartment,
      userIdentity
    FROM my_schema.user
    WHERE
      id = ?
    `,

    GetUserByEmployeeId: `
    SELECT
      id,
      userId,
      userName,
      employeeId,
      userPassword,
      userPhotoPath,
      userRoles,
      userEmail,
      userCellphone,
      userGender,
      userBirthday,
      userDepartment,
      userIdentity
    FROM my_schema.user
    WHERE
      employeeId = ?
    `,

    GetUserByToken: `
    SELECT
      id,
      userId,
      userName,
      employeeId,
      userPassword,
      userPhotoPath,
      userRoles,
      userEmail,
      userCellphone,
      userGender,
      userBirthday,
      userDepartment,
      userIdentity
    FROM my_schema.user
    WHERE
      userToken = ?
    `,

    AddUser: `
    INSERT INTO my_schema.user (userId, userName, employeeId, userPassword, userPhotoPath, userRoles, userEmail, userCellphone, userGender, userBirthday, userDepartment, userIdentity, userToken, createdTime, updatedTime)
      VALUES ?
    `,

    UpdateUserById: `
    UPDATE my_schema.user
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteUserById: `
    DELETE FROM my_schema.user
    WHERE
      id = ?
    `
  };